←
<navigation.php?ajax_request=1&token=cb85b8c538eb764911397279fe4bac32>
phpMyAdmin
<index.php?db=demo_mysql&table=user&token=cb85b8c538eb764911397279fe4bac32&goto=tbl_structure.php&back=tbl_structure.php>
Home <index.php?token=cb85b8c538eb764911397279fe4bac32>Log out
<index.php?db=demo_mysql&table=user&token=cb85b8c538eb764911397279fe4bac32&goto=tbl_structure.php&back=tbl_structure.php&old_usr=root>Query
window
<querywindow.php?db=demo_mysql&table=user&token=cb85b8c538eb764911397279fe4bac32&no_js=true>phpMyAdmin
documentation <./doc/html/index.html>Documentation
<./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Findex.html&token=cb85b8c538eb764911397279fe4bac32>Reload
navigation panel <#>

Loading…

  *
    //**cm9vdA==.MmN3ZWJ2bl9kZW1vcm9vdA==.MmN3ZWJ2bl9kZW1v0Expand/Collapse
    <#>
    Database operations
    <db_operations.php?server=1&db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
    2cwebvn_demo
    <db_structure.php?server=1&db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.Y2Rjb2w=cm9vdA==.Y2Rjb2w=0Expand/Collapse <#>
    Database operations
    <db_operations.php?server=1&db=cdcol&token=cb85b8c538eb764911397279fe4bac32>
    cdcol
    <db_structure.php?server=1&db=cdcol&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.ZGVtb19teXNxbA==cm9vdA==.ZGVtb19teXNxbA==0 <#>
    Database operations
    <db_operations.php?server=1&db=demo_mysql&token=cb85b8c538eb764911397279fe4bac32>
    demo_mysql
    <db_structure.php?server=1&db=demo_mysql&token=cb85b8c538eb764911397279fe4bac32>
      o tables0
        //tables0
        New
        <tbl_create.php?server=1&db=demo_mysql&token=cb85b8c538eb764911397279fe4bac32>
        New
        <tbl_create.php?server=1&db=demo_mysql&token=cb85b8c538eb764911397279fe4bac32>
      o
        //cm9vdA==.ZGVtb19teXNxbA==.dGFibGVz.dXNlcg==cm9vdA==.ZGVtb19teXNxbA==.VGFibGVz.dXNlcg==0tables0Expand/Collapse
        <#>
        Structure
        <tbl_structure.php?server=1&db=demo_mysql&table=user&token=cb85b8c538eb764911397279fe4bac32>
        user
        <sql.php?server=1&db=demo_mysql&table=user&pos=0&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0Expand/Collapse
    <#>
    Database operations
    <db_operations.php?server=1&db=information_schema&token=cb85b8c538eb764911397279fe4bac32>
    information_schema
    <db_structure.php?server=1&db=information_schema&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0Expand/Collapse <#>
    Database operations
    <db_operations.php?server=1&db=mysql&token=cb85b8c538eb764911397279fe4bac32>
    mysql
    <db_structure.php?server=1&db=mysql&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.TmV3cm9vdA==.TmV30Expand/Collapse <#>
    <server_databases.php?server=1&token=cb85b8c538eb764911397279fe4bac32>
    New
    <server_databases.php?server=1&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0Expand/Collapse
    <#>
    Database operations
    <db_operations.php?server=1&db=performance_schema&token=cb85b8c538eb764911397279fe4bac32>
    performance_schema
    <db_structure.php?server=1&db=performance_schema&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0Expand/Collapse
    <#>
    Database operations
    <db_operations.php?server=1&db=phpmyadmin&token=cb85b8c538eb764911397279fe4bac32>
    phpmyadmin
    <db_structure.php?server=1&db=phpmyadmin&token=cb85b8c538eb764911397279fe4bac32>
  *
    //**cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0Expand/Collapse <#>
    Database operations
    <db_operations.php?server=1&db=test&token=cb85b8c538eb764911397279fe4bac32>
    test
    <db_structure.php?server=1&db=test&token=cb85b8c538eb764911397279fe4bac32>
  *
    //cm9vdA==.d2ViYXV0aA==cm9vdA==.d2ViYXV0aA==0Expand/Collapse <#>
    Database operations
    <db_operations.php?server=1&db=webauth&token=cb85b8c538eb764911397279fe4bac32>
    webauth
    <db_structure.php?server=1&db=webauth&token=cb85b8c538eb764911397279fe4bac32>

Server: 127.0.0.1
<index.php?token=cb85b8c538eb764911397279fe4bac32> »Database:
2cwebvn_demo
<db_structure.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>

  * Structure Structure
    <db_structure.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * SQL SQL
    <db_sql.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Search Search
    <db_search.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Query Query
    <db_qbe.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Export Export
    <db_export.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Import Import
    <db_import.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Operations Operations
    <db_operations.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Privileges Privileges
    <server_privileges.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32&checkprivsdb=2cwebvn_demo&viewing_mode=db>
  * Routines Routines
    <db_routines.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * Events Events
    <db_events.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
  * More <#>
      o Triggers Triggers
        <db_triggers.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
      o Tracking Tracking
        <db_tracking.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>
      o Designer Designer
        <pmd_general.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>

<#>
Run SQL query/queries on database 2cwebvn_demo
<db_structure.php?db=2cwebvn_demo&token=cb85b8c538eb764911397279fe4bac32>:
Documentation
<./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fselect.html&token=cb85b8c538eb764911397279fe4bac32>

    )ENGINE=MyISAM DEFAULT CHARSET=utf8;

1

CREATE TABLE `member`(

2

    `id` INT NOT NULL AUTO_INCREMENT,

3

    `usename` VARCHAR(255)NOT NULL,

4

    `password`VARCHAR(32) NOT NULL,

5

    `email` VARCHAR(255)  NOT NULL,

6

    PRIMARY KEY(`id`)

7

    )ENGINE=MyISAM DEFAULT CHARSET=utf8;

 
 
Bookmark this SQL query:
Let every user access this bookmark
Replace existing bookmark of same name

[ Delimiter ]Show this query here againRetain query box

Hide query box

